package com.gxstnu.mapper;

import com.gxstnu.entity.Notice;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface NoticeMapper {
    List<Notice> selectAll(Notice notice);

    void insert(Notice notice);
    void updateById(Notice notice);

    @Select("select * from `notice` where title = #{title}")
    Notice selectByTitle(String title);

    @Delete("delete from notice where id = #{id}")
    void deleteById(Integer id);
}
